package com.yhyvr.console.controller;

import com.alibaba.fastjson.JSON;

import com.lz.mybatis.jdbc.auto.model.BoAppBanner;
import com.lz.mybatis.jdbc.auto.model.BoAppBannerExample;
import com.lz.mybatis.jdbc.auto.model.BoAppFeedback;
import com.lz.mybatis.jdbc.auto.model.BoAppFeedbackExample;
import com.lz.mybatis.jdbc.auto.model.BoBuyCart;
import com.lz.mybatis.jdbc.auto.model.BoBuyCartExample;
import com.lz.mybatis.jdbc.auto.model.BoComment;
import com.lz.mybatis.jdbc.auto.model.BoCommentExample;
import com.lz.mybatis.jdbc.auto.model.BoDictionary;
import com.lz.mybatis.jdbc.auto.model.BoDictionaryExample;
import com.lz.mybatis.jdbc.auto.model.BoGoods;
import com.lz.mybatis.jdbc.auto.model.BoGoodsExample;
import com.lz.mybatis.jdbc.auto.model.BoGoodsBanner;
import com.lz.mybatis.jdbc.auto.model.BoGoodsBannerExample;
import com.lz.mybatis.jdbc.auto.model.BoGoodsType;
import com.lz.mybatis.jdbc.auto.model.BoGoodsTypeExample;
import com.lz.mybatis.jdbc.auto.model.BoMessage;
import com.lz.mybatis.jdbc.auto.model.BoMessageExample;
import com.lz.mybatis.jdbc.auto.model.BoOrderLog;
import com.lz.mybatis.jdbc.auto.model.BoOrderLogExample;
import com.lz.mybatis.jdbc.auto.model.BoOrderOperLog;
import com.lz.mybatis.jdbc.auto.model.BoOrderOperLogExample;
import com.lz.mybatis.jdbc.auto.model.BoOrderRefundLog;
import com.lz.mybatis.jdbc.auto.model.BoOrderRefundLogExample;
import com.lz.mybatis.jdbc.auto.model.BoProxy;
import com.lz.mybatis.jdbc.auto.model.BoProxyExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyBind;
import com.lz.mybatis.jdbc.auto.model.BoProxyBindExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyMessage;
import com.lz.mybatis.jdbc.auto.model.BoProxyMessageExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrder;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrderExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrderGoods;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrderGoodsExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrderRefund;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrderRefundExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrderRefundGoods;
import com.lz.mybatis.jdbc.auto.model.BoProxyOrderRefundGoodsExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyPayLog;
import com.lz.mybatis.jdbc.auto.model.BoProxyPayLogExample;
import com.lz.mybatis.jdbc.auto.model.BoProxyShippingAddress;
import com.lz.mybatis.jdbc.auto.model.BoProxyShippingAddressExample;
import com.lz.mybatis.jdbc.auto.model.BoTasteGoods;
import com.lz.mybatis.jdbc.auto.model.BoTasteGoodsExample;
import com.lz.mybatis.jdbc.auto.model.BoTaster;
import com.lz.mybatis.jdbc.auto.model.BoTasterExample;
import com.lz.mybatis.jdbc.auto.model.BoWebNews;
import com.lz.mybatis.jdbc.auto.model.BoWebNewsExample;
import com.lz.mybatis.jdbc.auto.model.CommonRegion;
import com.lz.mybatis.jdbc.auto.model.CommonRegionExample;
import com.lz.mybatis.jdbc.auto.model.PhoneCode;
import com.lz.mybatis.jdbc.auto.model.PhoneCodeExample;
import com.lz.mybatis.jdbc.auto.model.SysDepartment;
import com.lz.mybatis.jdbc.auto.model.SysDepartmentExample;
import com.lz.mybatis.jdbc.auto.model.SysFile;
import com.lz.mybatis.jdbc.auto.model.SysFileExample;
import com.lz.mybatis.jdbc.auto.model.SysNav;
import com.lz.mybatis.jdbc.auto.model.SysNavExample;
import com.lz.mybatis.jdbc.auto.model.SysNavRole;
import com.lz.mybatis.jdbc.auto.model.SysNavRoleExample;
import com.lz.mybatis.jdbc.auto.model.SysReqUrl;
import com.lz.mybatis.jdbc.auto.model.SysReqUrlExample;
import com.lz.mybatis.jdbc.auto.model.SysReqUrlRole;
import com.lz.mybatis.jdbc.auto.model.SysReqUrlRoleExample;
import com.lz.mybatis.jdbc.auto.model.SysRole;
import com.lz.mybatis.jdbc.auto.model.SysRoleExample;
import com.lz.mybatis.jdbc.auto.model.SysUser;
import com.lz.mybatis.jdbc.auto.model.SysUserExample;
import com.lz.mybatis.jdbc.auto.model.SysUserRole;
import com.lz.mybatis.jdbc.auto.model.SysUserRoleExample;
import com.lz.mybatis.jdbc.auto.model.WxToken;
import com.lz.mybatis.jdbc.auto.model.WxTokenExample;
/**
 *
 */
public class ControllerQueryTool {

    public static  BoAppBannerExample.Criteria setBoAppBannerCriteria(String querys,BoAppBannerExample.Criteria criteria){
        BoAppBanner boAppBanner = JSON.parseObject(querys, BoAppBanner.class);
               if(boAppBanner.getTitle()!=null){
           criteria.andTitleEqualTo(boAppBanner.getTitle());
          }
       if(boAppBanner.getBannerImg()!=null){
           criteria.andBannerImgEqualTo(boAppBanner.getBannerImg());
          }
       if(boAppBanner.getTarget()!=null){
           criteria.andTargetEqualTo(boAppBanner.getTarget());
          }
       if(boAppBanner.getTargetType()!=null){
           criteria.andTargetTypeEqualTo(boAppBanner.getTargetType());
          }
       if(boAppBanner.getType()!=null){
           criteria.andTypeEqualTo(boAppBanner.getType());
          }
       if(boAppBanner.getSort()!=null){
           criteria.andSortEqualTo(boAppBanner.getSort());
          }
       if(boAppBanner.getStatus()!=null){
           criteria.andStatusEqualTo(boAppBanner.getStatus());
          }

        return criteria;
    }
    
    public static  String setBoAppBannerCriteria(String querys,StringBuffer sql , String alias){
                BoAppBanner boAppBanner = JSON.parseObject(querys, BoAppBanner.class);
                       if(boAppBanner.getTitle()!=null){
           sql.append(" and ").append(alias).append(".title").append(" = ").append(boAppBanner.getTitle()).append(" ");
          }
       if(boAppBanner.getBannerImg()!=null){
           sql.append(" and ").append(alias).append(".banner_img").append(" = ").append(boAppBanner.getBannerImg()).append(" ");
          }
       if(boAppBanner.getTarget()!=null){
           sql.append(" and ").append(alias).append(".target").append(" = ").append(boAppBanner.getTarget()).append(" ");
          }
       if(boAppBanner.getTargetType()!=null){
           sql.append(" and ").append(alias).append(".target_type").append(" = ").append(boAppBanner.getTargetType()).append(" ");
          }
       if(boAppBanner.getType()!=null){
           sql.append(" and ").append(alias).append(".type").append(" = ").append(boAppBanner.getType()).append(" ");
          }
       if(boAppBanner.getSort()!=null){
           sql.append(" and ").append(alias).append(".sort").append(" = ").append(boAppBanner.getSort()).append(" ");
          }
       if(boAppBanner.getStatus()!=null){
           sql.append(" and ").append(alias).append(".status").append(" = ").append(boAppBanner.getStatus()).append(" ");
          }

                return sql.toString();
            }
    public static  BoAppFeedbackExample.Criteria setBoAppFeedbackCriteria(String querys,BoAppFeedbackExample.Criteria criteria){
        BoAppFeedback boAppFeedback = JSON.parseObject(querys, BoAppFeedback.class);
               if(boAppFeedback.getAppId()!=null){
           criteria.andAppIdEqualTo(boAppFeedback.getAppId());
          }
       if(boAppFeedback.getUserId()!=null){
           criteria.andUserIdEqualTo(boAppFeedback.getUserId());
          }
       if(boAppFeedback.getContent()!=null){
           criteria.andContentEqualTo(boAppFeedback.getContent());
          }
       if(boAppFeedback.getContactInfo()!=null){
           criteria.andContactInfoEqualTo(boAppFeedback.getContactInfo());
          }

        return criteria;
    }
    
    public static  String setBoAppFeedbackCriteria(String querys,StringBuffer sql , String alias){
                BoAppFeedback boAppFeedback = JSON.parseObject(querys, BoAppFeedback.class);
                       if(boAppFeedback.getAppId()!=null){
           sql.append(" and ").append(alias).append(".app_id").append(" = ").append(boAppFeedback.getAppId()).append(" ");
          }
       if(boAppFeedback.getUserId()!=null){
           sql.append(" and ").append(alias).append(".user_id").append(" = ").append(boAppFeedback.getUserId()).append(" ");
          }
       if(boAppFeedback.getContent()!=null){
           sql.append(" and ").append(alias).append(".content").append(" = ").append(boAppFeedback.getContent()).append(" ");
          }
       if(boAppFeedback.getContactInfo()!=null){
           sql.append(" and ").append(alias).append(".contact_info").append(" = ").append(boAppFeedback.getContactInfo()).append(" ");
          }

                return sql.toString();
            }
    public static  BoBuyCartExample.Criteria setBoBuyCartCriteria(String querys,BoBuyCartExample.Criteria criteria){
        BoBuyCart boBuyCart = JSON.parseObject(querys, BoBuyCart.class);
               if(boBuyCart.getUserId()!=null){
           criteria.andUserIdEqualTo(boBuyCart.getUserId());
          }
       if(boBuyCart.getGoodsId()!=null){
           criteria.andGoodsIdEqualTo(boBuyCart.getGoodsId());
          }
       if(boBuyCart.getGoodsNumber()!=null){
           criteria.andGoodsNumberEqualTo(boBuyCart.getGoodsNumber());
          }

        return criteria;
    }
    
    public static  String setBoBuyCartCriteria(String querys,StringBuffer sql , String alias){
                BoBuyCart boBuyCart = JSON.parseObject(querys, BoBuyCart.class);
                       if(boBuyCart.getUserId()!=null){
           sql.append(" and ").append(alias).append(".user_id").append(" = ").append(boBuyCart.getUserId()).append(" ");
          }
       if(boBuyCart.getGoodsId()!=null){
           sql.append(" and ").append(alias).append(".goods_id").append(" = ").append(boBuyCart.getGoodsId()).append(" ");
          }
       if(boBuyCart.getGoodsNumber()!=null){
           sql.append(" and ").append(alias).append(".goods_number").append(" = ").append(boBuyCart.getGoodsNumber()).append(" ");
          }

                return sql.toString();
            }
    public static  BoCommentExample.Criteria setBoCommentCriteria(String querys,BoCommentExample.Criteria criteria){
        BoComment boComment = JSON.parseObject(querys, BoComment.class);
               if(boComment.getContent()!=null){
           criteria.andContentEqualTo(boComment.getContent());
          }
       if(boComment.getProxyId()!=null){
           criteria.andProxyIdEqualTo(boComment.getProxyId());
          }
       if(boComment.getImages()!=null){
           criteria.andImagesEqualTo(boComment.getImages());
          }
       if(boComment.getGradeFresh()!=null){
           criteria.andGradeFreshEqualTo(boComment.getGradeFresh());
          }
       if(boComment.getGradePack()!=null){
           criteria.andGradePackEqualTo(boComment.getGradePack());
          }
       if(boComment.getGradeClean()!=null){
           criteria.andGradeCleanEqualTo(boComment.getGradeClean());
          }
       if(boComment.getGradeTaste()!=null){
           criteria.andGradeTasteEqualTo(boComment.getGradeTaste());
          }
       if(boComment.getOrderId()!=null){
           criteria.andOrderIdEqualTo(boComment.getOrderId());
          }
       if(boComment.getGoodsId()!=null){
           criteria.andGoodsIdEqualTo(boComment.getGoodsId());
          }

        return criteria;
    }
    
    public static  String setBoCommentCriteria(String querys,StringBuffer sql , String alias){
                BoComment boComment = JSON.parseObject(querys, BoComment.class);
                       if(boComment.getContent()!=null){
           sql.append(" and ").append(alias).append(".content").append(" = ").append(boComment.getContent()).append(" ");
          }
       if(boComment.getProxyId()!=null){
           sql.append(" and ").append(alias).append(".proxy_id").append(" = ").append(boComment.getProxyId()).append(" ");
          }
       if(boComment.getImages()!=null){
           sql.append(" and ").append(alias).append(".images").append(" = ").append(boComment.getImages()).append(" ");
          }
       if(boComment.getGradeFresh()!=null){
           sql.append(" and ").append(alias).append(".grade_fresh").append(" = ").append(boComment.getGradeFresh()).append(" ");
          }
       if(boComment.getGradePack()!=null){
           sql.append(" and ").append(alias).append(".grade_pack").append(" = ").append(boComment.getGradePack()).append(" ");
          }
       if(boComment.getGradeClean()!=null){
           sql.append(" and ").append(alias).append(".grade_clean").append(" = ").append(boComment.getGradeClean()).append(" ");
          }
       if(boComment.getGradeTaste()!=null){
           sql.append(" and ").append(alias).append(".grade_taste").append(" = ").append(boComment.getGradeTaste()).append(" ");
          }
       if(boComment.getOrderId()!=null){
           sql.append(" and ").append(alias).append(".order_id").append(" = ").append(boComment.getOrderId()).append(" ");
          }
       if(boComment.getGoodsId()!=null){
           sql.append(" and ").append(alias).append(".goods_id").append(" = ").append(boComment.getGoodsId()).append(" ");
          }

                return sql.toString();
            }
    public static  BoDictionaryExample.Criteria setBoDictionaryCriteria(String querys,BoDictionaryExample.Criteria criteria){
        BoDictionary boDictionary = JSON.parseObject(querys, BoDictionary.class);
               if(boDictionary.getCode()!=null){
           criteria.andCodeEqualTo(boDictionary.getCode());
          }
       if(boDictionary.getValue()!=null){
           criteria.andValueEqualTo(boDictionary.getValue());
          }
       if(boDictionary.getDes()!=null){
           criteria.andDesEqualTo(boDictionary.getDes());
          }
       if(boDictionary.getName()!=null){
           criteria.andNameEqualTo(boDictionary.getName());
          }
       if(boDictionary.getDefaultValue()!=null){
           criteria.andDefaultValueEqualTo(boDictionary.getDefaultValue());
          }

        return criteria;
    }
    
    public static  String setBoDictionaryCriteria(String querys,StringBuffer sql , String alias){
                BoDictionary boDictionary = JSON.parseObject(querys, BoDictionary.class);
                       if(boDictionary.getCode()!=null){
           sql.append(" and ").append(alias).append(".code").append(" = ").append(boDictionary.getCode()).append(" ");
          }
       if(boDictionary.getValue()!=null){
           sql.append(" and ").append(alias).append(".value").append(" = ").append(boDictionary.getValue()).append(" ");
          }
       if(boDictionary.getDes()!=null){
           sql.append(" and ").append(alias).append(".des").append(" = ").append(boDictionary.getDes()).append(" ");
          }
       if(boDictionary.getName()!=null){
           sql.append(" and ").append(alias).append(".name").append(" = ").append(boDictionary.getName()).append(" ");
          }
       if(boDictionary.getDefaultValue()!=null){
           sql.append(" and ").append(alias).append(".default_value").append(" = ").append(boDictionary.getDefaultValue()).append(" ");
          }

                return sql.toString();
            }
    public static  BoGoodsExample.Criteria setBoGoodsCriteria(String querys,BoGoodsExample.Criteria criteria){
        BoGoods boGoods = JSON.parseObject(querys, BoGoods.class);
               if(boGoods.getGoodsTitle()!=null){
           criteria.andGoodsTitleEqualTo(boGoods.getGoodsTitle());
          }
       if(boGoods.getGoodsPrice()!=null){
           criteria.andGoodsPriceEqualTo(boGoods.getGoodsPrice());
          }
       if(boGoods.getGoodsOriginalPrice()!=null){
           criteria.andGoodsOriginalPriceEqualTo(boGoods.getGoodsOriginalPrice());
          }
       if(boGoods.getGoodsInventory()!=null){
           criteria.andGoodsInventoryEqualTo(boGoods.getGoodsInventory());
          }
       if(boGoods.getGoodsTypeId()!=null){
           criteria.andGoodsTypeIdEqualTo(boGoods.getGoodsTypeId());
          }
       if(boGoods.getGoodsTags()!=null){
           criteria.andGoodsTagsEqualTo(boGoods.getGoodsTags());
          }
       if(boGoods.getGoodsImage()!=null){
           criteria.andGoodsImageEqualTo(boGoods.getGoodsImage());
          }
       if(boGoods.getGoodsDescription()!=null){
           criteria.andGoodsDescriptionEqualTo(boGoods.getGoodsDescription());
          }
       if(boGoods.getRecommend()!=null){
           criteria.andRecommendEqualTo(boGoods.getRecommend());
          }
       if(boGoods.getState()!=null){
           criteria.andStateEqualTo(boGoods.getState());
          }
       if(boGoods.getSort()!=null){
           criteria.andSortEqualTo(boGoods.getSort());
          }

        return criteria;
    }
    
    public static  String setBoGoodsCriteria(String querys,StringBuffer sql , String alias){
                BoGoods boGoods = JSON.parseObject(querys, BoGoods.class);
                       if(boGoods.getGoodsTitle()!=null){
           sql.append(" and ").append(alias).append(".goods_title").append(" = ").append(boGoods.getGoodsTitle()).append(" ");
          }
       if(boGoods.getGoodsPrice()!=null){
           sql.append(" and ").append(alias).append(".goods_price").append(" = ").append(boGoods.getGoodsPrice()).append(" ");
          }
       if(boGoods.getGoodsOriginalPrice()!=null){
           sql.append(" and ").append(alias).append(".goods_original_price").append(" = ").append(boGoods.getGoodsOriginalPrice()).append(" ");
          }
       if(boGoods.getGoodsInventory()!=null){
           sql.append(" and ").append(alias).append(".goods_inventory").append(" = ").append(boGoods.getGoodsInventory()).append(" ");
          }
       if(boGoods.getGoodsTypeId()!=null){
           sql.append(" and ").append(alias).append(".goods_type_id").append(" = ").append(boGoods.getGoodsTypeId()).append(" ");
          }
       if(boGoods.getGoodsTags()!=null){
           sql.append(" and ").append(alias).append(".goods_tags").append(" = ").append(boGoods.getGoodsTags()).append(" ");
          }
       if(boGoods.getGoodsImage()!=null){
           sql.append(" and ").append(alias).append(".goods_image").append(" = ").append(boGoods.getGoodsImage()).append(" ");
          }
       if(boGoods.getGoodsDescription()!=null){
           sql.append(" and ").append(alias).append(".goods_description").append(" = ").append(boGoods.getGoodsDescription()).append(" ");
          }
       if(boGoods.getRecommend()!=null){
           sql.append(" and ").append(alias).append(".recommend").append(" = ").append(boGoods.getRecommend()).append(" ");
          }
       if(boGoods.getState()!=null){
           sql.append(" and ").append(alias).append(".state").append(" = ").append(boGoods.getState()).append(" ");
          }
       if(boGoods.getSort()!=null){
           sql.append(" and ").append(alias).append(".sort").append(" = ").append(boGoods.getSort()).append(" ");
          }

                return sql.toString();
            }
    public static  BoGoodsBannerExample.Criteria setBoGoodsBannerCriteria(String querys,BoGoodsBannerExample.Criteria criteria){
        BoGoodsBanner boGoodsBanner = JSON.parseObject(querys, BoGoodsBanner.class);
               if(boGoodsBanner.getGoodsId()!=null){
           criteria.andGoodsIdEqualTo(boGoodsBanner.getGoodsId());
          }
       if(boGoodsBanner.getBannerImg()!=null){
           criteria.andBannerImgEqualTo(boGoodsBanner.getBannerImg());
          }
       if(boGoodsBanner.getSort()!=null){
           criteria.andSortEqualTo(boGoodsBanner.getSort());
          }
       if(boGoodsBanner.getStatus()!=null){
           criteria.andStatusEqualTo(boGoodsBanner.getStatus());
          }

        return criteria;
    }
    
    public static  String setBoGoodsBannerCriteria(String querys,StringBuffer sql , String alias){
                BoGoodsBanner boGoodsBanner = JSON.parseObject(querys, BoGoodsBanner.class);
                       if(boGoodsBanner.getGoodsId()!=null){
           sql.append(" and ").append(alias).append(".goods_id").append(" = ").append(boGoodsBanner.getGoodsId()).append(" ");
          }
       if(boGoodsBanner.getBannerImg()!=null){
           sql.append(" and ").append(alias).append(".banner_img").append(" = ").append(boGoodsBanner.getBannerImg()).append(" ");
          }
       if(boGoodsBanner.getSort()!=null){
           sql.append(" and ").append(alias).append(".sort").append(" = ").append(boGoodsBanner.getSort()).append(" ");
          }
       if(boGoodsBanner.getStatus()!=null){
           sql.append(" and ").append(alias).append(".status").append(" = ").append(boGoodsBanner.getStatus()).append(" ");
          }

                return sql.toString();
            }
    public static  BoGoodsTypeExample.Criteria setBoGoodsTypeCriteria(String querys,BoGoodsTypeExample.Criteria criteria){
        BoGoodsType boGoodsType = JSON.parseObject(querys, BoGoodsType.class);
               if(boGoodsType.getGoodsTypeName()!=null){
           criteria.andGoodsTypeNameEqualTo(boGoodsType.getGoodsTypeName());
          }
       if(boGoodsType.getPid()!=null){
           criteria.andPidEqualTo(boGoodsType.getPid());
          }

        return criteria;
    }
    
    public static  String setBoGoodsTypeCriteria(String querys,StringBuffer sql , String alias){
                BoGoodsType boGoodsType = JSON.parseObject(querys, BoGoodsType.class);
                       if(boGoodsType.getGoodsTypeName()!=null){
           sql.append(" and ").append(alias).append(".goods_type_name").append(" = ").append(boGoodsType.getGoodsTypeName()).append(" ");
          }
       if(boGoodsType.getPid()!=null){
           sql.append(" and ").append(alias).append(".pid").append(" = ").append(boGoodsType.getPid()).append(" ");
          }

                return sql.toString();
            }
    public static  BoMessageExample.Criteria setBoMessageCriteria(String querys,BoMessageExample.Criteria criteria){
        BoMessage boMessage = JSON.parseObject(querys, BoMessage.class);
               if(boMessage.getMessageType()!=null){
           criteria.andMessageTypeEqualTo(boMessage.getMessageType());
          }
       if(boMessage.getMessageContent()!=null){
           criteria.andMessageContentEqualTo(boMessage.getMessageContent());
          }
       if(boMessage.getMessageTitle()!=null){
           criteria.andMessageTitleEqualTo(boMessage.getMessageTitle());
          }

        return criteria;
    }
    
    public static  String setBoMessageCriteria(String querys,StringBuffer sql , String alias){
                BoMessage boMessage = JSON.parseObject(querys, BoMessage.class);
                       if(boMessage.getMessageType()!=null){
           sql.append(" and ").append(alias).append(".message_type").append(" = ").append(boMessage.getMessageType()).append(" ");
          }
       if(boMessage.getMessageContent()!=null){
           sql.append(" and ").append(alias).append(".message_content").append(" = ").append(boMessage.getMessageContent()).append(" ");
          }
       if(boMessage.getMessageTitle()!=null){
           sql.append(" and ").append(alias).append(".message_title").append(" = ").append(boMessage.getMessageTitle()).append(" ");
          }

                return sql.toString();
            }
    public static  BoOrderLogExample.Criteria setBoOrderLogCriteria(String querys,BoOrderLogExample.Criteria criteria){
        BoOrderLog boOrderLog = JSON.parseObject(querys, BoOrderLog.class);
               if(boOrderLog.getOrderLogMessage()!=null){
           criteria.andOrderLogMessageEqualTo(boOrderLog.getOrderLogMessage());
          }
       if(boOrderLog.getOrderLogCreateTime()!=null){
           criteria.andOrderLogCreateTimeEqualTo(boOrderLog.getOrderLogCreateTime());
          }
       if(boOrderLog.getOrderId()!=null){
           criteria.andOrderIdEqualTo(boOrderLog.getOrderId());
          }

        return criteria;
    }
    
    public static  String setBoOrderLogCriteria(String querys,StringBuffer sql , String alias){
                BoOrderLog boOrderLog = JSON.parseObject(querys, BoOrderLog.class);
                       if(boOrderLog.getOrderLogMessage()!=null){
           sql.append(" and ").append(alias).append(".order_log_message").append(" = ").append(boOrderLog.getOrderLogMessage()).append(" ");
          }
       if(boOrderLog.getOrderLogCreateTime()!=null){
           sql.append(" and ").append(alias).append(".order_log_create_time").append(" = ").append(boOrderLog.getOrderLogCreateTime()).append(" ");
          }
       if(boOrderLog.getOrderId()!=null){
           sql.append(" and ").append(alias).append(".order_id").append(" = ").append(boOrderLog.getOrderId()).append(" ");
          }

                return sql.toString();
            }
    public static  BoOrderOperLogExample.Criteria setBoOrderOperLogCriteria(String querys,BoOrderOperLogExample.Criteria criteria){
        BoOrderOperLog boOrderOperLog = JSON.parseObject(querys, BoOrderOperLog.class);
               if(boOrderOperLog.getSysUserId()!=null){
           criteria.andSysUserIdEqualTo(boOrderOperLog.getSysUserId());
          }
       if(boOrderOperLog.getOperType()!=null){
           criteria.andOperTypeEqualTo(boOrderOperLog.getOperType());
          }
       if(boOrderOperLog.getOperDescription()!=null){
           criteria.andOperDescriptionEqualTo(boOrderOperLog.getOperDescription());
          }
       if(boOrderOperLog.getOrderId()!=null){
           criteria.andOrderIdEqualTo(boOrderOperLog.getOrderId());
          }

        return criteria;
    }
    
    public static  String setBoOrderOperLogCriteria(String querys,StringBuffer sql , String alias){
                BoOrderOperLog boOrderOperLog = JSON.parseObject(querys, BoOrderOperLog.class);
                       if(boOrderOperLog.getSysUserId()!=null){
           sql.append(" and ").append(alias).append(".sys_user_id").append(" = ").append(boOrderOperLog.getSysUserId()).append(" ");
          }
       if(boOrderOperLog.getOperType()!=null){
           sql.append(" and ").append(alias).append(".oper_type").append(" = ").append(boOrderOperLog.getOperType()).append(" ");
          }
       if(boOrderOperLog.getOperDescription()!=null){
           sql.append(" and ").append(alias).append(".oper_description").append(" = ").append(boOrderOperLog.getOperDescription()).append(" ");
          }
       if(boOrderOperLog.getOrderId()!=null){
           sql.append(" and ").append(alias).append(".order_id").append(" = ").append(boOrderOperLog.getOrderId()).append(" ");
          }

                return sql.toString();
            }
    public static  BoOrderRefundLogExample.Criteria setBoOrderRefundLogCriteria(String querys,BoOrderRefundLogExample.Criteria criteria){
        BoOrderRefundLog boOrderRefundLog = JSON.parseObject(querys, BoOrderRefundLog.class);
               if(boOrderRefundLog.getOrderRefundId()!=null){
           criteria.andOrderRefundIdEqualTo(boOrderRefundLog.getOrderRefundId());
          }
       if(boOrderRefundLog.getOrderLogMessage()!=null){
           criteria.andOrderLogMessageEqualTo(boOrderRefundLog.getOrderLogMessage());
          }
       if(boOrderRefundLog.getOrderLogCreateTime()!=null){
           criteria.andOrderLogCreateTimeEqualTo(boOrderRefundLog.getOrderLogCreateTime());
          }
       if(boOrderRefundLog.getOrderRefundType()!=null){
           criteria.andOrderRefundTypeEqualTo(boOrderRefundLog.getOrderRefundType());
          }

        return criteria;
    }
    
    public static  String setBoOrderRefundLogCriteria(String querys,StringBuffer sql , String alias){
                BoOrderRefundLog boOrderRefundLog = JSON.parseObject(querys, BoOrderRefundLog.class);
                       if(boOrderRefundLog.getOrderRefundId()!=null){
           sql.append(" and ").append(alias).append(".order_refund_id").append(" = ").append(boOrderRefundLog.getOrderRefundId()).append(" ");
          }
       if(boOrderRefundLog.getOrderLogMessage()!=null){
           sql.append(" and ").append(alias).append(".order_log_message").append(" = ").append(boOrderRefundLog.getOrderLogMessage()).append(" ");
          }
       if(boOrderRefundLog.getOrderLogCreateTime()!=null){
           sql.append(" and ").append(alias).append(".order_log_create_time").append(" = ").append(boOrderRefundLog.getOrderLogCreateTime()).append(" ");
          }
       if(boOrderRefundLog.getOrderRefundType()!=null){
           sql.append(" and ").append(alias).append(".order_refund_type").append(" = ").append(boOrderRefundLog.getOrderRefundType()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyExample.Criteria setBoProxyCriteria(String querys,BoProxyExample.Criteria criteria){
        BoProxy boProxy = JSON.parseObject(querys, BoProxy.class);
               if(boProxy.getBoProxyNickName()!=null){
           criteria.andBoProxyNickNameEqualTo(boProxy.getBoProxyNickName());
          }
       if(boProxy.getBoProxyPhone()!=null){
           criteria.andBoProxyPhoneEqualTo(boProxy.getBoProxyPhone());
          }
       if(boProxy.getBoProxyMail()!=null){
           criteria.andBoProxyMailEqualTo(boProxy.getBoProxyMail());
          }
       if(boProxy.getBoProxyPassword()!=null){
           criteria.andBoProxyPasswordEqualTo(boProxy.getBoProxyPassword());
          }
       if(boProxy.getBoProxyType()!=null){
           criteria.andBoProxyTypeEqualTo(boProxy.getBoProxyType());
          }
       if(boProxy.getBoProxyState()!=null){
           criteria.andBoProxyStateEqualTo(boProxy.getBoProxyState());
          }
       if(boProxy.getBoProxySex()!=null){
           criteria.andBoProxySexEqualTo(boProxy.getBoProxySex());
          }
       if(boProxy.getBoProxyHeadImage()!=null){
           criteria.andBoProxyHeadImageEqualTo(boProxy.getBoProxyHeadImage());
          }
       if(boProxy.getBoBanComment()!=null){
           criteria.andBoBanCommentEqualTo(boProxy.getBoBanComment());
          }

        return criteria;
    }
    
    public static  String setBoProxyCriteria(String querys,StringBuffer sql , String alias){
                BoProxy boProxy = JSON.parseObject(querys, BoProxy.class);
                       if(boProxy.getBoProxyNickName()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_nick_name").append(" = ").append(boProxy.getBoProxyNickName()).append(" ");
          }
       if(boProxy.getBoProxyPhone()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_phone").append(" = ").append(boProxy.getBoProxyPhone()).append(" ");
          }
       if(boProxy.getBoProxyMail()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_mail").append(" = ").append(boProxy.getBoProxyMail()).append(" ");
          }
       if(boProxy.getBoProxyPassword()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_password").append(" = ").append(boProxy.getBoProxyPassword()).append(" ");
          }
       if(boProxy.getBoProxyType()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_type").append(" = ").append(boProxy.getBoProxyType()).append(" ");
          }
       if(boProxy.getBoProxyState()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_state").append(" = ").append(boProxy.getBoProxyState()).append(" ");
          }
       if(boProxy.getBoProxySex()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_sex").append(" = ").append(boProxy.getBoProxySex()).append(" ");
          }
       if(boProxy.getBoProxyHeadImage()!=null){
           sql.append(" and ").append(alias).append(".bo_proxy_head_image").append(" = ").append(boProxy.getBoProxyHeadImage()).append(" ");
          }
       if(boProxy.getBoBanComment()!=null){
           sql.append(" and ").append(alias).append(".bo_ban_comment").append(" = ").append(boProxy.getBoBanComment()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyBindExample.Criteria setBoProxyBindCriteria(String querys,BoProxyBindExample.Criteria criteria){
        BoProxyBind boProxyBind = JSON.parseObject(querys, BoProxyBind.class);
               if(boProxyBind.getProxyId()!=null){
           criteria.andProxyIdEqualTo(boProxyBind.getProxyId());
          }
       if(boProxyBind.getBindType()!=null){
           criteria.andBindTypeEqualTo(boProxyBind.getBindType());
          }
       if(boProxyBind.getKeyid()!=null){
           criteria.andKeyidEqualTo(boProxyBind.getKeyid());
          }
       if(boProxyBind.getStatus()!=null){
           criteria.andStatusEqualTo(boProxyBind.getStatus());
          }

        return criteria;
    }
    
    public static  String setBoProxyBindCriteria(String querys,StringBuffer sql , String alias){
                BoProxyBind boProxyBind = JSON.parseObject(querys, BoProxyBind.class);
                       if(boProxyBind.getProxyId()!=null){
           sql.append(" and ").append(alias).append(".proxy_id").append(" = ").append(boProxyBind.getProxyId()).append(" ");
          }
       if(boProxyBind.getBindType()!=null){
           sql.append(" and ").append(alias).append(".bind_type").append(" = ").append(boProxyBind.getBindType()).append(" ");
          }
       if(boProxyBind.getKeyid()!=null){
           sql.append(" and ").append(alias).append(".keyid").append(" = ").append(boProxyBind.getKeyid()).append(" ");
          }
       if(boProxyBind.getStatus()!=null){
           sql.append(" and ").append(alias).append(".status").append(" = ").append(boProxyBind.getStatus()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyMessageExample.Criteria setBoProxyMessageCriteria(String querys,BoProxyMessageExample.Criteria criteria){
        BoProxyMessage boProxyMessage = JSON.parseObject(querys, BoProxyMessage.class);
               if(boProxyMessage.getMessageType()!=null){
           criteria.andMessageTypeEqualTo(boProxyMessage.getMessageType());
          }
       if(boProxyMessage.getMessageContent()!=null){
           criteria.andMessageContentEqualTo(boProxyMessage.getMessageContent());
          }
       if(boProxyMessage.getProxyId()!=null){
           criteria.andProxyIdEqualTo(boProxyMessage.getProxyId());
          }
       if(boProxyMessage.getHasRead()!=null){
           criteria.andHasReadEqualTo(boProxyMessage.getHasRead());
          }
       if(boProxyMessage.getMessageTitle()!=null){
           criteria.andMessageTitleEqualTo(boProxyMessage.getMessageTitle());
          }

        return criteria;
    }
    
    public static  String setBoProxyMessageCriteria(String querys,StringBuffer sql , String alias){
                BoProxyMessage boProxyMessage = JSON.parseObject(querys, BoProxyMessage.class);
                       if(boProxyMessage.getMessageType()!=null){
           sql.append(" and ").append(alias).append(".message_type").append(" = ").append(boProxyMessage.getMessageType()).append(" ");
          }
       if(boProxyMessage.getMessageContent()!=null){
           sql.append(" and ").append(alias).append(".message_content").append(" = ").append(boProxyMessage.getMessageContent()).append(" ");
          }
       if(boProxyMessage.getProxyId()!=null){
           sql.append(" and ").append(alias).append(".proxy_id").append(" = ").append(boProxyMessage.getProxyId()).append(" ");
          }
       if(boProxyMessage.getHasRead()!=null){
           sql.append(" and ").append(alias).append(".has_read").append(" = ").append(boProxyMessage.getHasRead()).append(" ");
          }
       if(boProxyMessage.getMessageTitle()!=null){
           sql.append(" and ").append(alias).append(".message_title").append(" = ").append(boProxyMessage.getMessageTitle()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyOrderExample.Criteria setBoProxyOrderCriteria(String querys,BoProxyOrderExample.Criteria criteria){
        BoProxyOrder boProxyOrder = JSON.parseObject(querys, BoProxyOrder.class);
               if(boProxyOrder.getOrderNumber()!=null){
           criteria.andOrderNumberEqualTo(boProxyOrder.getOrderNumber());
          }
       if(boProxyOrder.getOrderPayTime()!=null){
           criteria.andOrderPayTimeEqualTo(boProxyOrder.getOrderPayTime());
          }
       if(boProxyOrder.getOrderPayState()!=null){
           criteria.andOrderPayStateEqualTo(boProxyOrder.getOrderPayState());
          }
       if(boProxyOrder.getOrderDeliveryTime()!=null){
           criteria.andOrderDeliveryTimeEqualTo(boProxyOrder.getOrderDeliveryTime());
          }
       if(boProxyOrder.getOrderDeliveryState()!=null){
           criteria.andOrderDeliveryStateEqualTo(boProxyOrder.getOrderDeliveryState());
          }
       if(boProxyOrder.getOrderFreight()!=null){
           criteria.andOrderFreightEqualTo(boProxyOrder.getOrderFreight());
          }
       if(boProxyOrder.getOrderPrice()!=null){
           criteria.andOrderPriceEqualTo(boProxyOrder.getOrderPrice());
          }
       if(boProxyOrder.getOrderGoodsPrice()!=null){
           criteria.andOrderGoodsPriceEqualTo(boProxyOrder.getOrderGoodsPrice());
          }
       if(boProxyOrder.getOrderDiscountPrice()!=null){
           criteria.andOrderDiscountPriceEqualTo(boProxyOrder.getOrderDiscountPrice());
          }
       if(boProxyOrder.getOrderExpressRemark()!=null){
           criteria.andOrderExpressRemarkEqualTo(boProxyOrder.getOrderExpressRemark());
          }
       if(boProxyOrder.getOrderExpressNumber()!=null){
           criteria.andOrderExpressNumberEqualTo(boProxyOrder.getOrderExpressNumber());
          }
       if(boProxyOrder.getOrderExpressCompany()!=null){
           criteria.andOrderExpressCompanyEqualTo(boProxyOrder.getOrderExpressCompany());
          }
       if(boProxyOrder.getProxyId()!=null){
           criteria.andProxyIdEqualTo(boProxyOrder.getProxyId());
          }
       if(boProxyOrder.getShippingAddress()!=null){
           criteria.andShippingAddressEqualTo(boProxyOrder.getShippingAddress());
          }
       if(boProxyOrder.getWxTransactionId()!=null){
           criteria.andWxTransactionIdEqualTo(boProxyOrder.getWxTransactionId());
          }
       if(boProxyOrder.getAliTransactionId()!=null){
           criteria.andAliTransactionIdEqualTo(boProxyOrder.getAliTransactionId());
          }
       if(boProxyOrder.getOrderPayType()!=null){
           criteria.andOrderPayTypeEqualTo(boProxyOrder.getOrderPayType());
          }
       if(boProxyOrder.getOrderPayDeviceInfo()!=null){
           criteria.andOrderPayDeviceInfoEqualTo(boProxyOrder.getOrderPayDeviceInfo());
          }
       if(boProxyOrder.getOrderLockState()!=null){
           criteria.andOrderLockStateEqualTo(boProxyOrder.getOrderLockState());
          }
       if(boProxyOrder.getOrderType()!=null){
           criteria.andOrderTypeEqualTo(boProxyOrder.getOrderType());
          }
       if(boProxyOrder.getDeleteOrder()!=null){
           criteria.andDeleteOrderEqualTo(boProxyOrder.getDeleteOrder());
          }
       if(boProxyOrder.getTakeTheir()!=null){
           criteria.andTakeTheirEqualTo(boProxyOrder.getTakeTheir());
          }
       if(boProxyOrder.getOrderRemark()!=null){
           criteria.andOrderRemarkEqualTo(boProxyOrder.getOrderRemark());
          }
       if(boProxyOrder.getShippingPostcode()!=null){
           criteria.andShippingPostcodeEqualTo(boProxyOrder.getShippingPostcode());
          }
       if(boProxyOrder.getShippingCounty()!=null){
           criteria.andShippingCountyEqualTo(boProxyOrder.getShippingCounty());
          }
       if(boProxyOrder.getShippingCity()!=null){
           criteria.andShippingCityEqualTo(boProxyOrder.getShippingCity());
          }
       if(boProxyOrder.getShippingProvince()!=null){
           criteria.andShippingProvinceEqualTo(boProxyOrder.getShippingProvince());
          }
       if(boProxyOrder.getShippingConsignee()!=null){
           criteria.andShippingConsigneeEqualTo(boProxyOrder.getShippingConsignee());
          }
       if(boProxyOrder.getShippingPhone()!=null){
           criteria.andShippingPhoneEqualTo(boProxyOrder.getShippingPhone());
          }
       if(boProxyOrder.getShippingDetailAddress()!=null){
           criteria.andShippingDetailAddressEqualTo(boProxyOrder.getShippingDetailAddress());
          }
       if(boProxyOrder.getOrderInvoice()!=null){
           criteria.andOrderInvoiceEqualTo(boProxyOrder.getOrderInvoice());
          }
       if(boProxyOrder.getOrderSellChannel()!=null){
           criteria.andOrderSellChannelEqualTo(boProxyOrder.getOrderSellChannel());
          }

        return criteria;
    }
    
    public static  String setBoProxyOrderCriteria(String querys,StringBuffer sql , String alias){
                BoProxyOrder boProxyOrder = JSON.parseObject(querys, BoProxyOrder.class);
                       if(boProxyOrder.getOrderNumber()!=null){
           sql.append(" and ").append(alias).append(".order_number").append(" = ").append(boProxyOrder.getOrderNumber()).append(" ");
          }
       if(boProxyOrder.getOrderPayTime()!=null){
           sql.append(" and ").append(alias).append(".order_pay_time").append(" = ").append(boProxyOrder.getOrderPayTime()).append(" ");
          }
       if(boProxyOrder.getOrderPayState()!=null){
           sql.append(" and ").append(alias).append(".order_pay_state").append(" = ").append(boProxyOrder.getOrderPayState()).append(" ");
          }
       if(boProxyOrder.getOrderDeliveryTime()!=null){
           sql.append(" and ").append(alias).append(".order_delivery_time").append(" = ").append(boProxyOrder.getOrderDeliveryTime()).append(" ");
          }
       if(boProxyOrder.getOrderDeliveryState()!=null){
           sql.append(" and ").append(alias).append(".order_delivery_state").append(" = ").append(boProxyOrder.getOrderDeliveryState()).append(" ");
          }
       if(boProxyOrder.getOrderFreight()!=null){
           sql.append(" and ").append(alias).append(".order_freight").append(" = ").append(boProxyOrder.getOrderFreight()).append(" ");
          }
       if(boProxyOrder.getOrderPrice()!=null){
           sql.append(" and ").append(alias).append(".order_price").append(" = ").append(boProxyOrder.getOrderPrice()).append(" ");
          }
       if(boProxyOrder.getOrderGoodsPrice()!=null){
           sql.append(" and ").append(alias).append(".order_goods_price").append(" = ").append(boProxyOrder.getOrderGoodsPrice()).append(" ");
          }
       if(boProxyOrder.getOrderDiscountPrice()!=null){
           sql.append(" and ").append(alias).append(".order_discount_price").append(" = ").append(boProxyOrder.getOrderDiscountPrice()).append(" ");
          }
       if(boProxyOrder.getOrderExpressRemark()!=null){
           sql.append(" and ").append(alias).append(".order_express_remark").append(" = ").append(boProxyOrder.getOrderExpressRemark()).append(" ");
          }
       if(boProxyOrder.getOrderExpressNumber()!=null){
           sql.append(" and ").append(alias).append(".order_express_number").append(" = ").append(boProxyOrder.getOrderExpressNumber()).append(" ");
          }
       if(boProxyOrder.getOrderExpressCompany()!=null){
           sql.append(" and ").append(alias).append(".order_express_company").append(" = ").append(boProxyOrder.getOrderExpressCompany()).append(" ");
          }
       if(boProxyOrder.getProxyId()!=null){
           sql.append(" and ").append(alias).append(".proxy_id").append(" = ").append(boProxyOrder.getProxyId()).append(" ");
          }
       if(boProxyOrder.getShippingAddress()!=null){
           sql.append(" and ").append(alias).append(".shipping_address").append(" = ").append(boProxyOrder.getShippingAddress()).append(" ");
          }
       if(boProxyOrder.getWxTransactionId()!=null){
           sql.append(" and ").append(alias).append(".wx_transaction_id").append(" = ").append(boProxyOrder.getWxTransactionId()).append(" ");
          }
       if(boProxyOrder.getAliTransactionId()!=null){
           sql.append(" and ").append(alias).append(".ali_transaction_id").append(" = ").append(boProxyOrder.getAliTransactionId()).append(" ");
          }
       if(boProxyOrder.getOrderPayType()!=null){
           sql.append(" and ").append(alias).append(".order_pay_type").append(" = ").append(boProxyOrder.getOrderPayType()).append(" ");
          }
       if(boProxyOrder.getOrderPayDeviceInfo()!=null){
           sql.append(" and ").append(alias).append(".order_pay_device_info").append(" = ").append(boProxyOrder.getOrderPayDeviceInfo()).append(" ");
          }
       if(boProxyOrder.getOrderLockState()!=null){
           sql.append(" and ").append(alias).append(".order_lock_state").append(" = ").append(boProxyOrder.getOrderLockState()).append(" ");
          }
       if(boProxyOrder.getOrderType()!=null){
           sql.append(" and ").append(alias).append(".order_type").append(" = ").append(boProxyOrder.getOrderType()).append(" ");
          }
       if(boProxyOrder.getDeleteOrder()!=null){
           sql.append(" and ").append(alias).append(".delete_order").append(" = ").append(boProxyOrder.getDeleteOrder()).append(" ");
          }
       if(boProxyOrder.getTakeTheir()!=null){
           sql.append(" and ").append(alias).append(".take_their").append(" = ").append(boProxyOrder.getTakeTheir()).append(" ");
          }
       if(boProxyOrder.getOrderRemark()!=null){
           sql.append(" and ").append(alias).append(".order_remark").append(" = ").append(boProxyOrder.getOrderRemark()).append(" ");
          }
       if(boProxyOrder.getShippingPostcode()!=null){
           sql.append(" and ").append(alias).append(".shipping_postcode").append(" = ").append(boProxyOrder.getShippingPostcode()).append(" ");
          }
       if(boProxyOrder.getShippingCounty()!=null){
           sql.append(" and ").append(alias).append(".shipping_county").append(" = ").append(boProxyOrder.getShippingCounty()).append(" ");
          }
       if(boProxyOrder.getShippingCity()!=null){
           sql.append(" and ").append(alias).append(".shipping_city").append(" = ").append(boProxyOrder.getShippingCity()).append(" ");
          }
       if(boProxyOrder.getShippingProvince()!=null){
           sql.append(" and ").append(alias).append(".shipping_province").append(" = ").append(boProxyOrder.getShippingProvince()).append(" ");
          }
       if(boProxyOrder.getShippingConsignee()!=null){
           sql.append(" and ").append(alias).append(".shipping_consignee").append(" = ").append(boProxyOrder.getShippingConsignee()).append(" ");
          }
       if(boProxyOrder.getShippingPhone()!=null){
           sql.append(" and ").append(alias).append(".shipping_phone").append(" = ").append(boProxyOrder.getShippingPhone()).append(" ");
          }
       if(boProxyOrder.getShippingDetailAddress()!=null){
           sql.append(" and ").append(alias).append(".shipping_detail_address").append(" = ").append(boProxyOrder.getShippingDetailAddress()).append(" ");
          }
       if(boProxyOrder.getOrderInvoice()!=null){
           sql.append(" and ").append(alias).append(".order_invoice").append(" = ").append(boProxyOrder.getOrderInvoice()).append(" ");
          }
       if(boProxyOrder.getOrderSellChannel()!=null){
           sql.append(" and ").append(alias).append(".order_sell_channel").append(" = ").append(boProxyOrder.getOrderSellChannel()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyOrderGoodsExample.Criteria setBoProxyOrderGoodsCriteria(String querys,BoProxyOrderGoodsExample.Criteria criteria){
        BoProxyOrderGoods boProxyOrderGoods = JSON.parseObject(querys, BoProxyOrderGoods.class);
               if(boProxyOrderGoods.getOrderId()!=null){
           criteria.andOrderIdEqualTo(boProxyOrderGoods.getOrderId());
          }
       if(boProxyOrderGoods.getGoodsId()!=null){
           criteria.andGoodsIdEqualTo(boProxyOrderGoods.getGoodsId());
          }
       if(boProxyOrderGoods.getOrderGoodsTitle()!=null){
           criteria.andOrderGoodsTitleEqualTo(boProxyOrderGoods.getOrderGoodsTitle());
          }
       if(boProxyOrderGoods.getOrderGoodsNumber()!=null){
           criteria.andOrderGoodsNumberEqualTo(boProxyOrderGoods.getOrderGoodsNumber());
          }
       if(boProxyOrderGoods.getOrderGoodsPrice()!=null){
           criteria.andOrderGoodsPriceEqualTo(boProxyOrderGoods.getOrderGoodsPrice());
          }
       if(boProxyOrderGoods.getOrderGoodsImage()!=null){
           criteria.andOrderGoodsImageEqualTo(boProxyOrderGoods.getOrderGoodsImage());
          }

        return criteria;
    }
    
    public static  String setBoProxyOrderGoodsCriteria(String querys,StringBuffer sql , String alias){
                BoProxyOrderGoods boProxyOrderGoods = JSON.parseObject(querys, BoProxyOrderGoods.class);
                       if(boProxyOrderGoods.getOrderId()!=null){
           sql.append(" and ").append(alias).append(".order_id").append(" = ").append(boProxyOrderGoods.getOrderId()).append(" ");
          }
       if(boProxyOrderGoods.getGoodsId()!=null){
           sql.append(" and ").append(alias).append(".goods_id").append(" = ").append(boProxyOrderGoods.getGoodsId()).append(" ");
          }
       if(boProxyOrderGoods.getOrderGoodsTitle()!=null){
           sql.append(" and ").append(alias).append(".order_goods_title").append(" = ").append(boProxyOrderGoods.getOrderGoodsTitle()).append(" ");
          }
       if(boProxyOrderGoods.getOrderGoodsNumber()!=null){
           sql.append(" and ").append(alias).append(".order_goods_number").append(" = ").append(boProxyOrderGoods.getOrderGoodsNumber()).append(" ");
          }
       if(boProxyOrderGoods.getOrderGoodsPrice()!=null){
           sql.append(" and ").append(alias).append(".order_goods_price").append(" = ").append(boProxyOrderGoods.getOrderGoodsPrice()).append(" ");
          }
       if(boProxyOrderGoods.getOrderGoodsImage()!=null){
           sql.append(" and ").append(alias).append(".order_goods_image").append(" = ").append(boProxyOrderGoods.getOrderGoodsImage()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyOrderRefundExample.Criteria setBoProxyOrderRefundCriteria(String querys,BoProxyOrderRefundExample.Criteria criteria){
        BoProxyOrderRefund boProxyOrderRefund = JSON.parseObject(querys, BoProxyOrderRefund.class);
               if(boProxyOrderRefund.getOrderId()!=null){
           criteria.andOrderIdEqualTo(boProxyOrderRefund.getOrderId());
          }
       if(boProxyOrderRefund.getOrderExpressNumber()!=null){
           criteria.andOrderExpressNumberEqualTo(boProxyOrderRefund.getOrderExpressNumber());
          }
       if(boProxyOrderRefund.getOrderExpressCompany()!=null){
           criteria.andOrderExpressCompanyEqualTo(boProxyOrderRefund.getOrderExpressCompany());
          }
       if(boProxyOrderRefund.getProxyId()!=null){
           criteria.andProxyIdEqualTo(boProxyOrderRefund.getProxyId());
          }
       if(boProxyOrderRefund.getShippingAddress()!=null){
           criteria.andShippingAddressEqualTo(boProxyOrderRefund.getShippingAddress());
          }
       if(boProxyOrderRefund.getOrderAuditState()!=null){
           criteria.andOrderAuditStateEqualTo(boProxyOrderRefund.getOrderAuditState());
          }
       if(boProxyOrderRefund.getOrderAuditMessage()!=null){
           criteria.andOrderAuditMessageEqualTo(boProxyOrderRefund.getOrderAuditMessage());
          }
       if(boProxyOrderRefund.getConsignee()!=null){
           criteria.andConsigneeEqualTo(boProxyOrderRefund.getConsignee());
          }
       if(boProxyOrderRefund.getConsigneePhone()!=null){
           criteria.andConsigneePhoneEqualTo(boProxyOrderRefund.getConsigneePhone());
          }
       if(boProxyOrderRefund.getRefundCase()!=null){
           criteria.andRefundCaseEqualTo(boProxyOrderRefund.getRefundCase());
          }
       if(boProxyOrderRefund.getRefundNotes()!=null){
           criteria.andRefundNotesEqualTo(boProxyOrderRefund.getRefundNotes());
          }
       if(boProxyOrderRefund.getOrderExpressVoucher()!=null){
           criteria.andOrderExpressVoucherEqualTo(boProxyOrderRefund.getOrderExpressVoucher());
          }
       if(boProxyOrderRefund.getRefundPrice()!=null){
           criteria.andRefundPriceEqualTo(boProxyOrderRefund.getRefundPrice());
          }
       if(boProxyOrderRefund.getSysUserId()!=null){
           criteria.andSysUserIdEqualTo(boProxyOrderRefund.getSysUserId());
          }

        return criteria;
    }
    
    public static  String setBoProxyOrderRefundCriteria(String querys,StringBuffer sql , String alias){
                BoProxyOrderRefund boProxyOrderRefund = JSON.parseObject(querys, BoProxyOrderRefund.class);
                       if(boProxyOrderRefund.getOrderId()!=null){
           sql.append(" and ").append(alias).append(".order_id").append(" = ").append(boProxyOrderRefund.getOrderId()).append(" ");
          }
       if(boProxyOrderRefund.getOrderExpressNumber()!=null){
           sql.append(" and ").append(alias).append(".order_express_number").append(" = ").append(boProxyOrderRefund.getOrderExpressNumber()).append(" ");
          }
       if(boProxyOrderRefund.getOrderExpressCompany()!=null){
           sql.append(" and ").append(alias).append(".order_express_company").append(" = ").append(boProxyOrderRefund.getOrderExpressCompany()).append(" ");
          }
       if(boProxyOrderRefund.getProxyId()!=null){
           sql.append(" and ").append(alias).append(".proxy_id").append(" = ").append(boProxyOrderRefund.getProxyId()).append(" ");
          }
       if(boProxyOrderRefund.getShippingAddress()!=null){
           sql.append(" and ").append(alias).append(".shipping_address").append(" = ").append(boProxyOrderRefund.getShippingAddress()).append(" ");
          }
       if(boProxyOrderRefund.getOrderAuditState()!=null){
           sql.append(" and ").append(alias).append(".order_audit_state").append(" = ").append(boProxyOrderRefund.getOrderAuditState()).append(" ");
          }
       if(boProxyOrderRefund.getOrderAuditMessage()!=null){
           sql.append(" and ").append(alias).append(".order_audit_message").append(" = ").append(boProxyOrderRefund.getOrderAuditMessage()).append(" ");
          }
       if(boProxyOrderRefund.getConsignee()!=null){
           sql.append(" and ").append(alias).append(".consignee").append(" = ").append(boProxyOrderRefund.getConsignee()).append(" ");
          }
       if(boProxyOrderRefund.getConsigneePhone()!=null){
           sql.append(" and ").append(alias).append(".consignee_phone").append(" = ").append(boProxyOrderRefund.getConsigneePhone()).append(" ");
          }
       if(boProxyOrderRefund.getRefundCase()!=null){
           sql.append(" and ").append(alias).append(".refund_case").append(" = ").append(boProxyOrderRefund.getRefundCase()).append(" ");
          }
       if(boProxyOrderRefund.getRefundNotes()!=null){
           sql.append(" and ").append(alias).append(".refund_notes").append(" = ").append(boProxyOrderRefund.getRefundNotes()).append(" ");
          }
       if(boProxyOrderRefund.getOrderExpressVoucher()!=null){
           sql.append(" and ").append(alias).append(".order_express_voucher").append(" = ").append(boProxyOrderRefund.getOrderExpressVoucher()).append(" ");
          }
       if(boProxyOrderRefund.getRefundPrice()!=null){
           sql.append(" and ").append(alias).append(".refund_price").append(" = ").append(boProxyOrderRefund.getRefundPrice()).append(" ");
          }
       if(boProxyOrderRefund.getSysUserId()!=null){
           sql.append(" and ").append(alias).append(".sys_user_id").append(" = ").append(boProxyOrderRefund.getSysUserId()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyOrderRefundGoodsExample.Criteria setBoProxyOrderRefundGoodsCriteria(String querys,BoProxyOrderRefundGoodsExample.Criteria criteria){
        BoProxyOrderRefundGoods boProxyOrderRefundGoods = JSON.parseObject(querys, BoProxyOrderRefundGoods.class);
               if(boProxyOrderRefundGoods.getOrderId()!=null){
           criteria.andOrderIdEqualTo(boProxyOrderRefundGoods.getOrderId());
          }
       if(boProxyOrderRefundGoods.getGoodsId()!=null){
           criteria.andGoodsIdEqualTo(boProxyOrderRefundGoods.getGoodsId());
          }
       if(boProxyOrderRefundGoods.getOrderGoodsNumber()!=null){
           criteria.andOrderGoodsNumberEqualTo(boProxyOrderRefundGoods.getOrderGoodsNumber());
          }

        return criteria;
    }
    
    public static  String setBoProxyOrderRefundGoodsCriteria(String querys,StringBuffer sql , String alias){
                BoProxyOrderRefundGoods boProxyOrderRefundGoods = JSON.parseObject(querys, BoProxyOrderRefundGoods.class);
                       if(boProxyOrderRefundGoods.getOrderId()!=null){
           sql.append(" and ").append(alias).append(".order_id").append(" = ").append(boProxyOrderRefundGoods.getOrderId()).append(" ");
          }
       if(boProxyOrderRefundGoods.getGoodsId()!=null){
           sql.append(" and ").append(alias).append(".goods_id").append(" = ").append(boProxyOrderRefundGoods.getGoodsId()).append(" ");
          }
       if(boProxyOrderRefundGoods.getOrderGoodsNumber()!=null){
           sql.append(" and ").append(alias).append(".order_goods_number").append(" = ").append(boProxyOrderRefundGoods.getOrderGoodsNumber()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyPayLogExample.Criteria setBoProxyPayLogCriteria(String querys,BoProxyPayLogExample.Criteria criteria){
        BoProxyPayLog boProxyPayLog = JSON.parseObject(querys, BoProxyPayLog.class);
               if(boProxyPayLog.getPayLogOrderId()!=null){
           criteria.andPayLogOrderIdEqualTo(boProxyPayLog.getPayLogOrderId());
          }
       if(boProxyPayLog.getPayLogProxyId()!=null){
           criteria.andPayLogProxyIdEqualTo(boProxyPayLog.getPayLogProxyId());
          }
       if(boProxyPayLog.getPayLogPayType()!=null){
           criteria.andPayLogPayTypeEqualTo(boProxyPayLog.getPayLogPayType());
          }
       if(boProxyPayLog.getPayLogPlatformType()!=null){
           criteria.andPayLogPlatformTypeEqualTo(boProxyPayLog.getPayLogPlatformType());
          }
       if(boProxyPayLog.getPayLogMoney()!=null){
           criteria.andPayLogMoneyEqualTo(boProxyPayLog.getPayLogMoney());
          }
       if(boProxyPayLog.getPayLogRemark()!=null){
           criteria.andPayLogRemarkEqualTo(boProxyPayLog.getPayLogRemark());
          }

        return criteria;
    }
    
    public static  String setBoProxyPayLogCriteria(String querys,StringBuffer sql , String alias){
                BoProxyPayLog boProxyPayLog = JSON.parseObject(querys, BoProxyPayLog.class);
                       if(boProxyPayLog.getPayLogOrderId()!=null){
           sql.append(" and ").append(alias).append(".pay_log_order_id").append(" = ").append(boProxyPayLog.getPayLogOrderId()).append(" ");
          }
       if(boProxyPayLog.getPayLogProxyId()!=null){
           sql.append(" and ").append(alias).append(".pay_log_proxy_id").append(" = ").append(boProxyPayLog.getPayLogProxyId()).append(" ");
          }
       if(boProxyPayLog.getPayLogPayType()!=null){
           sql.append(" and ").append(alias).append(".pay_log_pay_type").append(" = ").append(boProxyPayLog.getPayLogPayType()).append(" ");
          }
       if(boProxyPayLog.getPayLogPlatformType()!=null){
           sql.append(" and ").append(alias).append(".pay_log_platform_type").append(" = ").append(boProxyPayLog.getPayLogPlatformType()).append(" ");
          }
       if(boProxyPayLog.getPayLogMoney()!=null){
           sql.append(" and ").append(alias).append(".pay_log_money").append(" = ").append(boProxyPayLog.getPayLogMoney()).append(" ");
          }
       if(boProxyPayLog.getPayLogRemark()!=null){
           sql.append(" and ").append(alias).append(".pay_log_remark").append(" = ").append(boProxyPayLog.getPayLogRemark()).append(" ");
          }

                return sql.toString();
            }
    public static  BoProxyShippingAddressExample.Criteria setBoProxyShippingAddressCriteria(String querys,BoProxyShippingAddressExample.Criteria criteria){
        BoProxyShippingAddress boProxyShippingAddress = JSON.parseObject(querys, BoProxyShippingAddress.class);
               if(boProxyShippingAddress.getPrpxyId()!=null){
           criteria.andPrpxyIdEqualTo(boProxyShippingAddress.getPrpxyId());
          }
       if(boProxyShippingAddress.getConsigneeName()!=null){
           criteria.andConsigneeNameEqualTo(boProxyShippingAddress.getConsigneeName());
          }
       if(boProxyShippingAddress.getConsigneePhone()!=null){
           criteria.andConsigneePhoneEqualTo(boProxyShippingAddress.getConsigneePhone());
          }
       if(boProxyShippingAddress.getShippingPostcode()!=null){
           criteria.andShippingPostcodeEqualTo(boProxyShippingAddress.getShippingPostcode());
          }
       if(boProxyShippingAddress.getShippingArea()!=null){
           criteria.andShippingAreaEqualTo(boProxyShippingAddress.getShippingArea());
          }
       if(boProxyShippingAddress.getShippingProvince()!=null){
           criteria.andShippingProvinceEqualTo(boProxyShippingAddress.getShippingProvince());
          }
       if(boProxyShippingAddress.getShippingCity()!=null){
           criteria.andShippingCityEqualTo(boProxyShippingAddress.getShippingCity());
          }
       if(boProxyShippingAddress.getShippingCounty()!=null){
           criteria.andShippingCountyEqualTo(boProxyShippingAddress.getShippingCounty());
          }
       if(boProxyShippingAddress.getShippingDetailAddress()!=null){
           criteria.andShippingDetailAddressEqualTo(boProxyShippingAddress.getShippingDetailAddress());
          }
       if(boProxyShippingAddress.getDefaultAddress()!=null){
           criteria.andDefaultAddressEqualTo(boProxyShippingAddress.getDefaultAddress());
          }

        return criteria;
    }
    
    public static  String setBoProxyShippingAddressCriteria(String querys,StringBuffer sql , String alias){
                BoProxyShippingAddress boProxyShippingAddress = JSON.parseObject(querys, BoProxyShippingAddress.class);
                       if(boProxyShippingAddress.getPrpxyId()!=null){
           sql.append(" and ").append(alias).append(".prpxy_id").append(" = ").append(boProxyShippingAddress.getPrpxyId()).append(" ");
          }
       if(boProxyShippingAddress.getConsigneeName()!=null){
           sql.append(" and ").append(alias).append(".consignee_name").append(" = ").append(boProxyShippingAddress.getConsigneeName()).append(" ");
          }
       if(boProxyShippingAddress.getConsigneePhone()!=null){
           sql.append(" and ").append(alias).append(".consignee_phone").append(" = ").append(boProxyShippingAddress.getConsigneePhone()).append(" ");
          }
       if(boProxyShippingAddress.getShippingPostcode()!=null){
           sql.append(" and ").append(alias).append(".shipping_postcode").append(" = ").append(boProxyShippingAddress.getShippingPostcode()).append(" ");
          }
       if(boProxyShippingAddress.getShippingArea()!=null){
           sql.append(" and ").append(alias).append(".shipping_area").append(" = ").append(boProxyShippingAddress.getShippingArea()).append(" ");
          }
       if(boProxyShippingAddress.getShippingProvince()!=null){
           sql.append(" and ").append(alias).append(".shipping_province").append(" = ").append(boProxyShippingAddress.getShippingProvince()).append(" ");
          }
       if(boProxyShippingAddress.getShippingCity()!=null){
           sql.append(" and ").append(alias).append(".shipping_city").append(" = ").append(boProxyShippingAddress.getShippingCity()).append(" ");
          }
       if(boProxyShippingAddress.getShippingCounty()!=null){
           sql.append(" and ").append(alias).append(".shipping_county").append(" = ").append(boProxyShippingAddress.getShippingCounty()).append(" ");
          }
       if(boProxyShippingAddress.getShippingDetailAddress()!=null){
           sql.append(" and ").append(alias).append(".shipping_detail_address").append(" = ").append(boProxyShippingAddress.getShippingDetailAddress()).append(" ");
          }
       if(boProxyShippingAddress.getDefaultAddress()!=null){
           sql.append(" and ").append(alias).append(".default_address").append(" = ").append(boProxyShippingAddress.getDefaultAddress()).append(" ");
          }

                return sql.toString();
            }
    public static  BoTasteGoodsExample.Criteria setBoTasteGoodsCriteria(String querys,BoTasteGoodsExample.Criteria criteria){
        BoTasteGoods boTasteGoods = JSON.parseObject(querys, BoTasteGoods.class);
               if(boTasteGoods.getBoGoodsId()!=null){
           criteria.andBoGoodsIdEqualTo(boTasteGoods.getBoGoodsId());
          }
       if(boTasteGoods.getBoTotalNum()!=null){
           criteria.andBoTotalNumEqualTo(boTasteGoods.getBoTotalNum());
          }
       if(boTasteGoods.getBoRemainNum()!=null){
           criteria.andBoRemainNumEqualTo(boTasteGoods.getBoRemainNum());
          }
       if(boTasteGoods.getBoStartDate()!=null){
           criteria.andBoStartDateEqualTo(boTasteGoods.getBoStartDate());
          }
       if(boTasteGoods.getBoEndDate()!=null){
           criteria.andBoEndDateEqualTo(boTasteGoods.getBoEndDate());
          }
       if(boTasteGoods.getBoStatus()!=null){
           criteria.andBoStatusEqualTo(boTasteGoods.getBoStatus());
          }
       if(boTasteGoods.getTastePrice()!=null){
           criteria.andTastePriceEqualTo(boTasteGoods.getTastePrice());
          }

        return criteria;
    }
    
    public static  String setBoTasteGoodsCriteria(String querys,StringBuffer sql , String alias){
                BoTasteGoods boTasteGoods = JSON.parseObject(querys, BoTasteGoods.class);
                       if(boTasteGoods.getBoGoodsId()!=null){
           sql.append(" and ").append(alias).append(".bo_goods_id").append(" = ").append(boTasteGoods.getBoGoodsId()).append(" ");
          }
       if(boTasteGoods.getBoTotalNum()!=null){
           sql.append(" and ").append(alias).append(".bo_total_num").append(" = ").append(boTasteGoods.getBoTotalNum()).append(" ");
          }
       if(boTasteGoods.getBoRemainNum()!=null){
           sql.append(" and ").append(alias).append(".bo_remain_num").append(" = ").append(boTasteGoods.getBoRemainNum()).append(" ");
          }
       if(boTasteGoods.getBoStartDate()!=null){
           sql.append(" and ").append(alias).append(".bo_start_date").append(" = ").append(boTasteGoods.getBoStartDate()).append(" ");
          }
       if(boTasteGoods.getBoEndDate()!=null){
           sql.append(" and ").append(alias).append(".bo_end_date").append(" = ").append(boTasteGoods.getBoEndDate()).append(" ");
          }
       if(boTasteGoods.getBoStatus()!=null){
           sql.append(" and ").append(alias).append(".bo_status").append(" = ").append(boTasteGoods.getBoStatus()).append(" ");
          }
       if(boTasteGoods.getTastePrice()!=null){
           sql.append(" and ").append(alias).append(".taste_price").append(" = ").append(boTasteGoods.getTastePrice()).append(" ");
          }

                return sql.toString();
            }
    public static  BoTasterExample.Criteria setBoTasterCriteria(String querys,BoTasterExample.Criteria criteria){
        BoTaster boTaster = JSON.parseObject(querys, BoTaster.class);
               if(boTaster.getBoBpProxyId()!=null){
           criteria.andBoBpProxyIdEqualTo(boTaster.getBoBpProxyId());
          }
       if(boTaster.getBoTrueName()!=null){
           criteria.andBoTrueNameEqualTo(boTaster.getBoTrueName());
          }
       if(boTaster.getBoIdentifyNum()!=null){
           criteria.andBoIdentifyNumEqualTo(boTaster.getBoIdentifyNum());
          }
       if(boTaster.getBoApplyTime()!=null){
           criteria.andBoApplyTimeEqualTo(boTaster.getBoApplyTime());
          }
       if(boTaster.getBoReviewTime()!=null){
           criteria.andBoReviewTimeEqualTo(boTaster.getBoReviewTime());
          }
       if(boTaster.getBoStatus()!=null){
           criteria.andBoStatusEqualTo(boTaster.getBoStatus());
          }

        return criteria;
    }
    
    public static  String setBoTasterCriteria(String querys,StringBuffer sql , String alias){
                BoTaster boTaster = JSON.parseObject(querys, BoTaster.class);
                       if(boTaster.getBoBpProxyId()!=null){
           sql.append(" and ").append(alias).append(".bo_bp_proxy_id").append(" = ").append(boTaster.getBoBpProxyId()).append(" ");
          }
       if(boTaster.getBoTrueName()!=null){
           sql.append(" and ").append(alias).append(".bo_true_name").append(" = ").append(boTaster.getBoTrueName()).append(" ");
          }
       if(boTaster.getBoIdentifyNum()!=null){
           sql.append(" and ").append(alias).append(".bo_identify_num").append(" = ").append(boTaster.getBoIdentifyNum()).append(" ");
          }
       if(boTaster.getBoApplyTime()!=null){
           sql.append(" and ").append(alias).append(".bo_apply_time").append(" = ").append(boTaster.getBoApplyTime()).append(" ");
          }
       if(boTaster.getBoReviewTime()!=null){
           sql.append(" and ").append(alias).append(".bo_review_time").append(" = ").append(boTaster.getBoReviewTime()).append(" ");
          }
       if(boTaster.getBoStatus()!=null){
           sql.append(" and ").append(alias).append(".bo_status").append(" = ").append(boTaster.getBoStatus()).append(" ");
          }

                return sql.toString();
            }
    public static  BoWebNewsExample.Criteria setBoWebNewsCriteria(String querys,BoWebNewsExample.Criteria criteria){
        BoWebNews boWebNews = JSON.parseObject(querys, BoWebNews.class);
               if(boWebNews.getPublish()!=null){
           criteria.andPublishEqualTo(boWebNews.getPublish());
          }
       if(boWebNews.getAuthor()!=null){
           criteria.andAuthorEqualTo(boWebNews.getAuthor());
          }
       if(boWebNews.getSource()!=null){
           criteria.andSourceEqualTo(boWebNews.getSource());
          }
       if(boWebNews.getCover()!=null){
           criteria.andCoverEqualTo(boWebNews.getCover());
          }
       if(boWebNews.getTitle()!=null){
           criteria.andTitleEqualTo(boWebNews.getTitle());
          }
       if(boWebNews.getNewsType()!=null){
           criteria.andNewsTypeEqualTo(boWebNews.getNewsType());
          }
       if(boWebNews.getIntro()!=null){
           criteria.andIntroEqualTo(boWebNews.getIntro());
          }

        return criteria;
    }
    
    public static  String setBoWebNewsCriteria(String querys,StringBuffer sql , String alias){
                BoWebNews boWebNews = JSON.parseObject(querys, BoWebNews.class);
                       if(boWebNews.getPublish()!=null){
           sql.append(" and ").append(alias).append(".publish").append(" = ").append(boWebNews.getPublish()).append(" ");
          }
       if(boWebNews.getAuthor()!=null){
           sql.append(" and ").append(alias).append(".author").append(" = ").append(boWebNews.getAuthor()).append(" ");
          }
       if(boWebNews.getSource()!=null){
           sql.append(" and ").append(alias).append(".source").append(" = ").append(boWebNews.getSource()).append(" ");
          }
       if(boWebNews.getContent()!=null){
           sql.append(" and ").append(alias).append(".content").append(" = ").append(boWebNews.getContent()).append(" ");
          }
       if(boWebNews.getCover()!=null){
           sql.append(" and ").append(alias).append(".cover").append(" = ").append(boWebNews.getCover()).append(" ");
          }
       if(boWebNews.getTitle()!=null){
           sql.append(" and ").append(alias).append(".title").append(" = ").append(boWebNews.getTitle()).append(" ");
          }
       if(boWebNews.getNewsType()!=null){
           sql.append(" and ").append(alias).append(".news_type").append(" = ").append(boWebNews.getNewsType()).append(" ");
          }
       if(boWebNews.getIntro()!=null){
           sql.append(" and ").append(alias).append(".intro").append(" = ").append(boWebNews.getIntro()).append(" ");
          }

                return sql.toString();
            }
    public static  CommonRegionExample.Criteria setCommonRegionCriteria(String querys,CommonRegionExample.Criteria criteria){
        CommonRegion commonRegion = JSON.parseObject(querys, CommonRegion.class);
               if(commonRegion.getPid()!=null){
           criteria.andPidEqualTo(commonRegion.getPid());
          }
       if(commonRegion.getName()!=null){
           criteria.andNameEqualTo(commonRegion.getName());
          }
       if(commonRegion.getLevel()!=null){
           criteria.andLevelEqualTo(commonRegion.getLevel());
          }
       if(commonRegion.getSort()!=null){
           criteria.andSortEqualTo(commonRegion.getSort());
          }
       if(commonRegion.getRecommend()!=null){
           criteria.andRecommendEqualTo(commonRegion.getRecommend());
          }
       if(commonRegion.getRecommendSort()!=null){
           criteria.andRecommendSortEqualTo(commonRegion.getRecommendSort());
          }
       if(commonRegion.getMark()!=null){
           criteria.andMarkEqualTo(commonRegion.getMark());
          }

        return criteria;
    }
    
    public static  String setCommonRegionCriteria(String querys,StringBuffer sql , String alias){
                CommonRegion commonRegion = JSON.parseObject(querys, CommonRegion.class);
                       if(commonRegion.getPid()!=null){
           sql.append(" and ").append(alias).append(".pid").append(" = ").append(commonRegion.getPid()).append(" ");
          }
       if(commonRegion.getName()!=null){
           sql.append(" and ").append(alias).append(".name").append(" = ").append(commonRegion.getName()).append(" ");
          }
       if(commonRegion.getLevel()!=null){
           sql.append(" and ").append(alias).append(".level").append(" = ").append(commonRegion.getLevel()).append(" ");
          }
       if(commonRegion.getSort()!=null){
           sql.append(" and ").append(alias).append(".sort").append(" = ").append(commonRegion.getSort()).append(" ");
          }
       if(commonRegion.getRecommend()!=null){
           sql.append(" and ").append(alias).append(".recommend").append(" = ").append(commonRegion.getRecommend()).append(" ");
          }
       if(commonRegion.getRecommendSort()!=null){
           sql.append(" and ").append(alias).append(".recommend_sort").append(" = ").append(commonRegion.getRecommendSort()).append(" ");
          }
       if(commonRegion.getMark()!=null){
           sql.append(" and ").append(alias).append(".mark").append(" = ").append(commonRegion.getMark()).append(" ");
          }

                return sql.toString();
            }
    public static  PhoneCodeExample.Criteria setPhoneCodeCriteria(String querys,PhoneCodeExample.Criteria criteria){
        PhoneCode phoneCode = JSON.parseObject(querys, PhoneCode.class);
               if(phoneCode.getPhone()!=null){
           criteria.andPhoneEqualTo(phoneCode.getPhone());
          }
       if(phoneCode.getCode()!=null){
           criteria.andCodeEqualTo(phoneCode.getCode());
          }
       if(phoneCode.getExpiresTime()!=null){
           criteria.andExpiresTimeEqualTo(phoneCode.getExpiresTime());
          }

        return criteria;
    }
    
    public static  String setPhoneCodeCriteria(String querys,StringBuffer sql , String alias){
                PhoneCode phoneCode = JSON.parseObject(querys, PhoneCode.class);
                       if(phoneCode.getPhone()!=null){
           sql.append(" and ").append(alias).append(".phone").append(" = ").append(phoneCode.getPhone()).append(" ");
          }
       if(phoneCode.getCode()!=null){
           sql.append(" and ").append(alias).append(".code").append(" = ").append(phoneCode.getCode()).append(" ");
          }
       if(phoneCode.getExpiresTime()!=null){
           sql.append(" and ").append(alias).append(".expires_time").append(" = ").append(phoneCode.getExpiresTime()).append(" ");
          }

                return sql.toString();
            }
    public static  SysDepartmentExample.Criteria setSysDepartmentCriteria(String querys,SysDepartmentExample.Criteria criteria){
        SysDepartment sysDepartment = JSON.parseObject(querys, SysDepartment.class);
               if(sysDepartment.getDepartmentName()!=null){
           criteria.andDepartmentNameEqualTo(sysDepartment.getDepartmentName());
          }
       if(sysDepartment.getParentId()!=null){
           criteria.andParentIdEqualTo(sysDepartment.getParentId());
          }

        return criteria;
    }
    
    public static  String setSysDepartmentCriteria(String querys,StringBuffer sql , String alias){
                SysDepartment sysDepartment = JSON.parseObject(querys, SysDepartment.class);
                       if(sysDepartment.getDepartmentName()!=null){
           sql.append(" and ").append(alias).append(".department_name").append(" = ").append(sysDepartment.getDepartmentName()).append(" ");
          }
       if(sysDepartment.getParentId()!=null){
           sql.append(" and ").append(alias).append(".parent_id").append(" = ").append(sysDepartment.getParentId()).append(" ");
          }

                return sql.toString();
            }
    public static  SysFileExample.Criteria setSysFileCriteria(String querys,SysFileExample.Criteria criteria){
        SysFile sysFile = JSON.parseObject(querys, SysFile.class);
               if(sysFile.getFileName()!=null){
           criteria.andFileNameEqualTo(sysFile.getFileName());
          }
       if(sysFile.getFileType()!=null){
           criteria.andFileTypeEqualTo(sysFile.getFileType());
          }
       if(sysFile.getFileHeight()!=null){
           criteria.andFileHeightEqualTo(sysFile.getFileHeight());
          }
       if(sysFile.getFileWidth()!=null){
           criteria.andFileWidthEqualTo(sysFile.getFileWidth());
          }
       if(sysFile.getFileSize()!=null){
           criteria.andFileSizeEqualTo(sysFile.getFileSize());
          }
       if(sysFile.getFileUrl()!=null){
           criteria.andFileUrlEqualTo(sysFile.getFileUrl());
          }
       if(sysFile.getLocal()!=null){
           criteria.andLocalEqualTo(sysFile.getLocal());
          }
       if(sysFile.getFileMd5()!=null){
           criteria.andFileMd5EqualTo(sysFile.getFileMd5());
          }

        return criteria;
    }
    
    public static  String setSysFileCriteria(String querys,StringBuffer sql , String alias){
                SysFile sysFile = JSON.parseObject(querys, SysFile.class);
                       if(sysFile.getFileName()!=null){
           sql.append(" and ").append(alias).append(".file_name").append(" = ").append(sysFile.getFileName()).append(" ");
          }
       if(sysFile.getFileType()!=null){
           sql.append(" and ").append(alias).append(".file_type").append(" = ").append(sysFile.getFileType()).append(" ");
          }
       if(sysFile.getFileHeight()!=null){
           sql.append(" and ").append(alias).append(".file_height").append(" = ").append(sysFile.getFileHeight()).append(" ");
          }
       if(sysFile.getFileWidth()!=null){
           sql.append(" and ").append(alias).append(".file_width").append(" = ").append(sysFile.getFileWidth()).append(" ");
          }
       if(sysFile.getFileSize()!=null){
           sql.append(" and ").append(alias).append(".file_size").append(" = ").append(sysFile.getFileSize()).append(" ");
          }
       if(sysFile.getFileUrl()!=null){
           sql.append(" and ").append(alias).append(".file_url").append(" = ").append(sysFile.getFileUrl()).append(" ");
          }
       if(sysFile.getLocal()!=null){
           sql.append(" and ").append(alias).append(".local").append(" = ").append(sysFile.getLocal()).append(" ");
          }
       if(sysFile.getFileMd5()!=null){
           sql.append(" and ").append(alias).append(".file_md5").append(" = ").append(sysFile.getFileMd5()).append(" ");
          }

                return sql.toString();
            }
    public static  SysNavExample.Criteria setSysNavCriteria(String querys,SysNavExample.Criteria criteria){
        SysNav sysNav = JSON.parseObject(querys, SysNav.class);
               if(sysNav.getName()!=null){
           criteria.andNameEqualTo(sysNav.getName());
          }
       if(sysNav.getUrl()!=null){
           criteria.andUrlEqualTo(sysNav.getUrl());
          }
       if(sysNav.getUrlTarget()!=null){
           criteria.andUrlTargetEqualTo(sysNav.getUrlTarget());
          }
       if(sysNav.getIconUrl()!=null){
           criteria.andIconUrlEqualTo(sysNav.getIconUrl());
          }
       if(sysNav.getSort()!=null){
           criteria.andSortEqualTo(sysNav.getSort());
          }
       if(sysNav.getPid()!=null){
           criteria.andPidEqualTo(sysNav.getPid());
          }
       if(sysNav.getStatus()!=null){
           criteria.andStatusEqualTo(sysNav.getStatus());
          }
       if(sysNav.getLevels()!=null){
           criteria.andLevelsEqualTo(sysNav.getLevels());
          }
       if(sysNav.getType()!=null){
           criteria.andTypeEqualTo(sysNav.getType());
          }

        return criteria;
    }
    
    public static  String setSysNavCriteria(String querys,StringBuffer sql , String alias){
                SysNav sysNav = JSON.parseObject(querys, SysNav.class);
                       if(sysNav.getName()!=null){
           sql.append(" and ").append(alias).append(".name").append(" = ").append(sysNav.getName()).append(" ");
          }
       if(sysNav.getUrl()!=null){
           sql.append(" and ").append(alias).append(".url").append(" = ").append(sysNav.getUrl()).append(" ");
          }
       if(sysNav.getUrlTarget()!=null){
           sql.append(" and ").append(alias).append(".url_target").append(" = ").append(sysNav.getUrlTarget()).append(" ");
          }
       if(sysNav.getIconUrl()!=null){
           sql.append(" and ").append(alias).append(".icon_url").append(" = ").append(sysNav.getIconUrl()).append(" ");
          }
       if(sysNav.getSort()!=null){
           sql.append(" and ").append(alias).append(".sort").append(" = ").append(sysNav.getSort()).append(" ");
          }
       if(sysNav.getPid()!=null){
           sql.append(" and ").append(alias).append(".pid").append(" = ").append(sysNav.getPid()).append(" ");
          }
       if(sysNav.getStatus()!=null){
           sql.append(" and ").append(alias).append(".status").append(" = ").append(sysNav.getStatus()).append(" ");
          }
       if(sysNav.getLevels()!=null){
           sql.append(" and ").append(alias).append(".levels").append(" = ").append(sysNav.getLevels()).append(" ");
          }
       if(sysNav.getType()!=null){
           sql.append(" and ").append(alias).append(".type").append(" = ").append(sysNav.getType()).append(" ");
          }

                return sql.toString();
            }
    public static  SysNavRoleExample.Criteria setSysNavRoleCriteria(String querys,SysNavRoleExample.Criteria criteria){
        SysNavRole sysNavRole = JSON.parseObject(querys, SysNavRole.class);
               if(sysNavRole.getNavId()!=null){
           criteria.andNavIdEqualTo(sysNavRole.getNavId());
          }
       if(sysNavRole.getRoleId()!=null){
           criteria.andRoleIdEqualTo(sysNavRole.getRoleId());
          }

        return criteria;
    }
    
    public static  String setSysNavRoleCriteria(String querys,StringBuffer sql , String alias){
                SysNavRole sysNavRole = JSON.parseObject(querys, SysNavRole.class);
                       if(sysNavRole.getNavId()!=null){
           sql.append(" and ").append(alias).append(".nav_id").append(" = ").append(sysNavRole.getNavId()).append(" ");
          }
       if(sysNavRole.getRoleId()!=null){
           sql.append(" and ").append(alias).append(".role_id").append(" = ").append(sysNavRole.getRoleId()).append(" ");
          }

                return sql.toString();
            }
    public static  SysReqUrlExample.Criteria setSysReqUrlCriteria(String querys,SysReqUrlExample.Criteria criteria){
        SysReqUrl sysReqUrl = JSON.parseObject(querys, SysReqUrl.class);
               if(sysReqUrl.getUrl()!=null){
           criteria.andUrlEqualTo(sysReqUrl.getUrl());
          }
       if(sysReqUrl.getName()!=null){
           criteria.andNameEqualTo(sysReqUrl.getName());
          }
       if(sysReqUrl.getDescription()!=null){
           criteria.andDescriptionEqualTo(sysReqUrl.getDescription());
          }

        return criteria;
    }
    
    public static  String setSysReqUrlCriteria(String querys,StringBuffer sql , String alias){
                SysReqUrl sysReqUrl = JSON.parseObject(querys, SysReqUrl.class);
                       if(sysReqUrl.getUrl()!=null){
           sql.append(" and ").append(alias).append(".url").append(" = ").append(sysReqUrl.getUrl()).append(" ");
          }
       if(sysReqUrl.getName()!=null){
           sql.append(" and ").append(alias).append(".name").append(" = ").append(sysReqUrl.getName()).append(" ");
          }
       if(sysReqUrl.getDescription()!=null){
           sql.append(" and ").append(alias).append(".description").append(" = ").append(sysReqUrl.getDescription()).append(" ");
          }

                return sql.toString();
            }
    public static  SysReqUrlRoleExample.Criteria setSysReqUrlRoleCriteria(String querys,SysReqUrlRoleExample.Criteria criteria){
        SysReqUrlRole sysReqUrlRole = JSON.parseObject(querys, SysReqUrlRole.class);
               if(sysReqUrlRole.getRoleId()!=null){
           criteria.andRoleIdEqualTo(sysReqUrlRole.getRoleId());
          }
       if(sysReqUrlRole.getReqUrl()!=null){
           criteria.andReqUrlEqualTo(sysReqUrlRole.getReqUrl());
          }

        return criteria;
    }
    
    public static  String setSysReqUrlRoleCriteria(String querys,StringBuffer sql , String alias){
                SysReqUrlRole sysReqUrlRole = JSON.parseObject(querys, SysReqUrlRole.class);
                       if(sysReqUrlRole.getRoleId()!=null){
           sql.append(" and ").append(alias).append(".role_id").append(" = ").append(sysReqUrlRole.getRoleId()).append(" ");
          }
       if(sysReqUrlRole.getReqUrl()!=null){
           sql.append(" and ").append(alias).append(".req_url").append(" = ").append(sysReqUrlRole.getReqUrl()).append(" ");
          }

                return sql.toString();
            }
    public static  SysRoleExample.Criteria setSysRoleCriteria(String querys,SysRoleExample.Criteria criteria){
        SysRole sysRole = JSON.parseObject(querys, SysRole.class);
               if(sysRole.getRoleName()!=null){
           criteria.andRoleNameEqualTo(sysRole.getRoleName());
          }
       if(sysRole.getStatus()!=null){
           criteria.andStatusEqualTo(sysRole.getStatus());
          }
       if(sysRole.getPid()!=null){
           criteria.andPidEqualTo(sysRole.getPid());
          }

        return criteria;
    }
    
    public static  String setSysRoleCriteria(String querys,StringBuffer sql , String alias){
                SysRole sysRole = JSON.parseObject(querys, SysRole.class);
                       if(sysRole.getRoleName()!=null){
           sql.append(" and ").append(alias).append(".role_name").append(" = ").append(sysRole.getRoleName()).append(" ");
          }
       if(sysRole.getStatus()!=null){
           sql.append(" and ").append(alias).append(".status").append(" = ").append(sysRole.getStatus()).append(" ");
          }
       if(sysRole.getPid()!=null){
           sql.append(" and ").append(alias).append(".pid").append(" = ").append(sysRole.getPid()).append(" ");
          }

                return sql.toString();
            }
    public static  SysUserExample.Criteria setSysUserCriteria(String querys,SysUserExample.Criteria criteria){
        SysUser sysUser = JSON.parseObject(querys, SysUser.class);
               if(sysUser.getUserName()!=null){
           criteria.andUserNameEqualTo(sysUser.getUserName());
          }
       if(sysUser.getNickName()!=null){
           criteria.andNickNameEqualTo(sysUser.getNickName());
          }
       if(sysUser.getUserPassword()!=null){
           criteria.andUserPasswordEqualTo(sysUser.getUserPassword());
          }
       if(sysUser.getUserPic()!=null){
           criteria.andUserPicEqualTo(sysUser.getUserPic());
          }
       if(sysUser.getVerifyEmail()!=null){
           criteria.andVerifyEmailEqualTo(sysUser.getVerifyEmail());
          }
       if(sysUser.getPhone()!=null){
           criteria.andPhoneEqualTo(sysUser.getPhone());
          }
       if(sysUser.getEmail()!=null){
           criteria.andEmailEqualTo(sysUser.getEmail());
          }
       if(sysUser.getCreateUserId()!=null){
           criteria.andCreateUserIdEqualTo(sysUser.getCreateUserId());
          }
       if(sysUser.getUpdateUserId()!=null){
           criteria.andUpdateUserIdEqualTo(sysUser.getUpdateUserId());
          }
       if(sysUser.getUserType()!=null){
           criteria.andUserTypeEqualTo(sysUser.getUserType());
          }
       if(sysUser.getIsAuth()!=null){
           criteria.andIsAuthEqualTo(sysUser.getIsAuth());
          }
       if(sysUser.getStatus()!=null){
           criteria.andStatusEqualTo(sysUser.getStatus());
          }
       if(sysUser.getDepartmentId()!=null){
           criteria.andDepartmentIdEqualTo(sysUser.getDepartmentId());
          }

        return criteria;
    }
    
    public static  String setSysUserCriteria(String querys,StringBuffer sql , String alias){
                SysUser sysUser = JSON.parseObject(querys, SysUser.class);
                       if(sysUser.getUserName()!=null){
           sql.append(" and ").append(alias).append(".user_name").append(" = ").append(sysUser.getUserName()).append(" ");
          }
       if(sysUser.getNickName()!=null){
           sql.append(" and ").append(alias).append(".nick_name").append(" = ").append(sysUser.getNickName()).append(" ");
          }
       if(sysUser.getUserPassword()!=null){
           sql.append(" and ").append(alias).append(".user_password").append(" = ").append(sysUser.getUserPassword()).append(" ");
          }
       if(sysUser.getUserPic()!=null){
           sql.append(" and ").append(alias).append(".user_pic").append(" = ").append(sysUser.getUserPic()).append(" ");
          }
       if(sysUser.getVerifyEmail()!=null){
           sql.append(" and ").append(alias).append(".verify_email").append(" = ").append(sysUser.getVerifyEmail()).append(" ");
          }
       if(sysUser.getPhone()!=null){
           sql.append(" and ").append(alias).append(".phone").append(" = ").append(sysUser.getPhone()).append(" ");
          }
       if(sysUser.getEmail()!=null){
           sql.append(" and ").append(alias).append(".email").append(" = ").append(sysUser.getEmail()).append(" ");
          }
       if(sysUser.getCreateUserId()!=null){
           sql.append(" and ").append(alias).append(".create_user_id").append(" = ").append(sysUser.getCreateUserId()).append(" ");
          }
       if(sysUser.getUpdateUserId()!=null){
           sql.append(" and ").append(alias).append(".update_user_id").append(" = ").append(sysUser.getUpdateUserId()).append(" ");
          }
       if(sysUser.getUserType()!=null){
           sql.append(" and ").append(alias).append(".user_type").append(" = ").append(sysUser.getUserType()).append(" ");
          }
       if(sysUser.getIsAuth()!=null){
           sql.append(" and ").append(alias).append(".is_auth").append(" = ").append(sysUser.getIsAuth()).append(" ");
          }
       if(sysUser.getStatus()!=null){
           sql.append(" and ").append(alias).append(".status").append(" = ").append(sysUser.getStatus()).append(" ");
          }
       if(sysUser.getDepartmentId()!=null){
           sql.append(" and ").append(alias).append(".department_id").append(" = ").append(sysUser.getDepartmentId()).append(" ");
          }

                return sql.toString();
            }
    public static  SysUserRoleExample.Criteria setSysUserRoleCriteria(String querys,SysUserRoleExample.Criteria criteria){
        SysUserRole sysUserRole = JSON.parseObject(querys, SysUserRole.class);
               if(sysUserRole.getSuId()!=null){
           criteria.andSuIdEqualTo(sysUserRole.getSuId());
          }
       if(sysUserRole.getRoleId()!=null){
           criteria.andRoleIdEqualTo(sysUserRole.getRoleId());
          }

        return criteria;
    }
    
    public static  String setSysUserRoleCriteria(String querys,StringBuffer sql , String alias){
                SysUserRole sysUserRole = JSON.parseObject(querys, SysUserRole.class);
                       if(sysUserRole.getSuId()!=null){
           sql.append(" and ").append(alias).append(".su_id").append(" = ").append(sysUserRole.getSuId()).append(" ");
          }
       if(sysUserRole.getRoleId()!=null){
           sql.append(" and ").append(alias).append(".role_id").append(" = ").append(sysUserRole.getRoleId()).append(" ");
          }

                return sql.toString();
            }
    public static  WxTokenExample.Criteria setWxTokenCriteria(String querys,WxTokenExample.Criteria criteria){
        WxToken wxToken = JSON.parseObject(querys, WxToken.class);
               if(wxToken.getEndTime()!=null){
           criteria.andEndTimeEqualTo(wxToken.getEndTime());
          }
       if(wxToken.getToken()!=null){
           criteria.andTokenEqualTo(wxToken.getToken());
          }
       if(wxToken.getName()!=null){
           criteria.andNameEqualTo(wxToken.getName());
          }
       if(wxToken.getState()!=null){
           criteria.andStateEqualTo(wxToken.getState());
          }

        return criteria;
    }
    
    public static  String setWxTokenCriteria(String querys,StringBuffer sql , String alias){
                WxToken wxToken = JSON.parseObject(querys, WxToken.class);
                       if(wxToken.getEndTime()!=null){
           sql.append(" and ").append(alias).append(".end_time").append(" = ").append(wxToken.getEndTime()).append(" ");
          }
       if(wxToken.getToken()!=null){
           sql.append(" and ").append(alias).append(".token").append(" = ").append(wxToken.getToken()).append(" ");
          }
       if(wxToken.getName()!=null){
           sql.append(" and ").append(alias).append(".name").append(" = ").append(wxToken.getName()).append(" ");
          }
       if(wxToken.getState()!=null){
           sql.append(" and ").append(alias).append(".state").append(" = ").append(wxToken.getState()).append(" ");
          }

                return sql.toString();
            }

}
